how to create Multi-Statement Table Valued function in sql server .

Question

Anonymous User · Answer

--let’s start querying create a table.
and CREATE TABLE UserMasters(
and and and and and and UserId int IDENTITY(1,1) primary key,
and and and and and and LoginName nvarchar(max) ,
and and and and and and password nvarchar(max) ,
and and and and and and UserName nvarchar(max) and and )
and CREATE TABLE ProductMasters(
and and and and and and ProductId int IDENTITY(1,1) primary key,
and and and and and and ProductName nvarchar(max) ,
and and and and and and Price decimal(18, 2)and ,
and and and and and and CategoryId intand , 
and and and and and and Userid int
and )
and --We will now create a table valued function, which returns
the total of price filtered by a given category . Write the following code in
your query pad – 
and create function fnGetUsernamewithProductMasters
(and 
and @categoryId int
)
returns @customerwithproduct
table(
UserName varchar(100),
ProductName varchar(100),
Price decimal(10,2)
)
as
begin
insert @customerwithproduct
selectand and b.UserName, a.ProductName,a.Priceand and from ProductMasters as a inner join UserMasters as b on a.Userid=b.Userid where CategoryId=@categoryId 
return
endand 
--The above function returns an table.
To test this function, we will write some code as shown below – 
select * from dbo.fnGetUsernamewithProductMasters(1)and 
Result

forum

how to create Multi-Statement Table Valued function in sql server .

Anonymous User

1 Answers

Liked By